HomeFabricsGalleryDesign OptionsAdviceFabric ShortlistFabric SwatchesMeasuring & FittingGet a PriceYour OrderAdmin
Fabrics Home
Search
Plains
Akoko Plains
Amilie Plains
Bamboo
Kalaya Plains
Linara Colours
Linara Neutrals
Lucido
Geneva
Makeda Plains
Weaves
Americano
Amilie
Charlbury
Folia Checks and Stripes
Juniper Embroideries
Melbury Large Checks and Stripes
Melbury Smaller Checks, Stripes and Plains
Porto
Stratton
Zaika
Naturals
Basics
Prints
Akoko
Melinki One
Melinki Two

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',2)+POW(G1-,2)+POW(B1-,2),POW(R2-,2)+POW(G2-,2)+POW(B2-,2),POW(R1-,2)+POW(G1-,2)' at line 1

SELECT *, LEAST(POW(R1-,2)+POW(G1-,2)+POW(B1-,2),POW(R2-,2)+POW(G2-,2)+POW(B2-,2),POW(R1-,2)+POW(G1-,2)+POW(B1-,2),POW(R2-,2)+POW(G2-,2)+POW(B2-,2)) AS COLOURSCORE FROM FABRICS, FABRICRANGE WHERE FABRICS.FABRICRANGENO=FABRICRANGE.FABRICRANGENO AND HEXCOLOR1<>"" AND FABRICRANGE.FABRICRANGESTATUSNO<>4 AND HIDE=0 ORDER BY COLOURSCORE LIMIT 0,9/var/www/romansdirect.co.uk/search.php L 597 # 2 : mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given
/var/www/romansdirect.co.uk/search.php L 661 # 2 : mysqli_free_result() expects parameter 1 to be mysqli_result, bool given
Step 1:
Click a colour from the slide
Step 2:
Click a shade from the grid
Step 3:
Click Search

Narrow down by fabric type: Or, search by word(s):